from django.db import models

class ZoneInfo(models.Model):
    zone_id = models.AutoField(primary_key=True)
    zone_name = models.CharField(max_length=255, blank=True, null=True)
    zone_address = models.CharField(max_length=255, blank=True, null=True)
    zone_admin = models.CharField(max_length=255, blank=True, null=True)
    zone_admin_phone = models.CharField(max_length=255, blank=True, null=True)
    zone_admin_email = models.CharField(max_length=255, blank=True, null=True)
    zone_openid = models.CharField(max_length=255, blank=True, null=True)
    zone_count = models.IntegerField(blank=True, null=True)
    zone_idle_count = models.IntegerField(blank=True, null=True)
    zone_last_electric = models.FloatField(blank=True, null=True)
    zone_electric = models.FloatField(blank=True, null=True)
    zone_last_water = models.FloatField(blank=True, null=True)
    zone_water = models.FloatField(blank=True, null=True)
    zone_last_house = models.FloatField(blank=True, null=True)
    zone_house = models.FloatField(blank=True, null=True)

    class Meta:
        db_table = 'zone_info'
